perl toggle operator for extracting one table from mysql dump file
We did it with a nifty one liner perl command that uses the TOGGLE operator. zcat fast.dmp.12082014_13_03.sql.gz |perl -ne ‘if (/CREATE TABLE `budget`/../UNLOCK/ ) {print $_; }’ > budget.1208.sql This looks for lines in the dump between lines that match … Continue reading perl toggle operator for extracting one table from mysql dump file
Copy and paste this URL into your WordPress site to embed
Copy and paste this code into your site to embed